﻿
PRINT 'Creating the local job: differential backup'
:r .\JOB-Backup_Differential.sql

PRINT 'Creating the local job: full backup'
:r .\JOB-Backup_Full.sql

PRINT 'Creating the local job: log backup'
:r .\JOB-Backup_Log.sql

PRINT 'Creating the local job: clean backup history'
:r .\JOB-Cleanup_Backup_History.sql

PRINT 'Creating the local job: CHECKDB'
:r .\JOB-Maintenance_CheckDB.sql

PRINT 'Creating the local job: Index Defrag'
:r .\JOB-Maintenance_Indexes.sql

PRINT 'Creating the local job: Performance Monitor'
:r .\JOB-Monitoring_Performance.sql

PRINT 'Creating the local job: Performance Rollup and Prune'
:r .\JOB-Monitoring_Performance_Hourly_Rollup_And_Prune.sql
